﻿CREATE proc phannhommenu_loaddanhsachnhommenu  
@MaNhom int  
as  
select a.ID,a.MenuID,b.TenMenu,b.TenForm,B.TenModule,b.TenThuMuc,b.Hinh,  
a.Quyen_CapNhat,a.Quyen_Xem,a.Quyen_Xoa,a.MenuCha,a.Cap  ,c.CommandName,c.IDCN
from QuanTri_PhanNhomMenu a,DanhMuc_Menu b  ,DanhMuc_Command c
Where a.MenuID=b.MenuID and a.MaNhomMenuND=@MaNhom  and a.IDCN=c.IDCN 
order by a.Cap  